Visual industry KPIs to analyze Auto Repair Data Mart 5

Summary:

1. Compare Referral growth by Referral Companies from 2016 - 2018.
2. Total Sales vs Target sales comparison by Month and Year.
3. Delivery status by all shops.
4. Repair order growth year over year.
5. Total sales by territory.
6. Total sales by different categories.

Note: Above file have multiple batch of codes for all summary points. Go batch by batch following each GIF.

1. Compare Referral growth by Referral Companies from 2016 - 2018.

Created a view for this KPI, to compare the Referral companies referral trend year over year.

First create view and then execute that view to get referral growth from 2016 to 2018 for:

· NegativeGrowth

· DoubleGrowth

· NoDifference

· NewRefferals

· MoreThanDoubleGrowth

· PositiveGrowth

2. Total Sales vs Target sales comparison by Month and Year.

Created a Store Procedure for this KPI, to compare total sales by month vs target sales. In this Store procedure we have two input parameters for month and year. So please pass two parameters or else it will throw error.

3. Delivery status:

We classified the repair order completions by shop into Four delivery statuses:

· Early repair Order completions

· On time Repair Order completions

· Late Repair Order Completions

· On process Repair Orders

4. Repair order growth year over year from 2016 - 2018

5. Total sales by territory for Central, south & West

6. Total sales by different categories:

· Total Paint Sales by shop.

· Total Mechanics Sales by shop.

· Total Body Sales by shop.

· Total Detail Sales by shop.

· Total Electric Sales by shop.

· Repair Orders Status by each shop.

· Repair orders that are possible Total losses.

· Towed Repair Orders by shop.

· Total Cost of Rentals by shop.